UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZDBDCbbCPI1zv4fIIHYZO+RHzKAgGEw1eJ/+9KSqpo='
WHERE
key_id = 'ad502f6d5b89fb5a8a3fc91efe95c951d3c6852d69141acd70fb249e8c4f0565'
AND (
token = 'XZDBDCbbCPI1zv4fIIHYZO+RHzKAgGEw1eJ/+9KSqpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)