UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oz5vTDt663if9zIKEBrDMqA0sMYncmcP8MgFcUc9nlA='
WHERE
key_id = '3961032d52fb07793c9cc9faee8aaef2de874e8b407be95dc2b5dfb2b9bf9e10'
AND (
token = 'oz5vTDt663if9zIKEBrDMqA0sMYncmcP8MgFcUc9nlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)