UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCs4GsbcznwhXYjUSQQSHv3Hn/rHgvoEp4+tjHu0nvo='
WHERE
key_id = 'de0be05570b8024cfc95d6a034bdc9fc25c34b1f6d28d444e1abb72809ef1832'
AND (
token = 'BCs4GsbcznwhXYjUSQQSHv3Hn/rHgvoEp4+tjHu0nvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)