UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q1/TOGcecFHn6+475HNF6MCI4sP59Xzj8gihGd+fIN4='
WHERE
key_id = 'd7e769d4a83fa175a7a1c7f5678a97deca7d181fdedaa1830b58f51627a6a55a'
AND (
token = 'Q1/TOGcecFHn6+475HNF6MCI4sP59Xzj8gihGd+fIN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)