UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4X7LSi0croKDAsYIIoohCZqbfqfUIKrMHRi7l/qyDgs='
WHERE
key_id = '3df4780343aec86adc9f40bad9ad46cbd78835ed303aff527e12628f1a5cfe4d'
AND (
token = '4X7LSi0croKDAsYIIoohCZqbfqfUIKrMHRi7l/qyDgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)