UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZSG3XZCrSKEAqNMOIigVGcT/QkDjNThAWXIwslknYUw='
WHERE
key_id = 'b221c8dc89c50faac998603bfcf9ecdadef50abda003fce888369f70d93201b2'
AND (
token = 'ZSG3XZCrSKEAqNMOIigVGcT/QkDjNThAWXIwslknYUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)