UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcSwCmKx0yyQWBJJqxrU/K393d9F2ilcRTSYcmQIRdU='
WHERE
key_id = '8cdbaabdfba7e54904cf36c7b8a1e0713a99f122d74702113d46f7612e2e3de1'
AND (
token = 'QcSwCmKx0yyQWBJJqxrU/K393d9F2ilcRTSYcmQIRdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)