UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n/srRRxp100ME7jcH2o7tKevgmc1tT7c/awLTqKaaN4='
WHERE
key_id = '5583491bd2af733a80e50b791bcf3bf306516861cc7af0f098e4ab226a62efbc'
AND (
token = 'n/srRRxp100ME7jcH2o7tKevgmc1tT7c/awLTqKaaN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)