UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6HMxfS1TPKyq+5T1Nb0Z98fJI8AJuhsMXjWtodgcRQ='
WHERE
key_id = '0c8b7e9f0e50a60eb64fa502c4e69a39b3e6fc9362bd977e927ad8aa275b37a4'
AND (
token = 'Z6HMxfS1TPKyq+5T1Nb0Z98fJI8AJuhsMXjWtodgcRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)