UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyfhhnLD4F/xyG7ZZ4PEybC6Ip3aSmvzFOdU2AQqzKc='
WHERE
key_id = '62c502d82ea86f95177ea401c6b860bcedc969257ba24609451f2fcee84ce567'
AND (
token = 'ZyfhhnLD4F/xyG7ZZ4PEybC6Ip3aSmvzFOdU2AQqzKc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)