UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nTGnA2EtkOzHSQYK1w10g4DWNg1hYpf8JgSl62gpqk='
WHERE
key_id = '1a1a60476565df0352ef971caa64e9056a6f985f3ce731d1e91a41239b76fe51'
AND (
token = '8nTGnA2EtkOzHSQYK1w10g4DWNg1hYpf8JgSl62gpqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)