UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7XedcFEcJ77QniaETxXHmW1SEeKBLqAXYfLjzlYBc8='
WHERE
key_id = '6270a98fd5cbf4b50e793bfdaf85c7b13bf831fd518aa7165a3adbdef39fc6bf'
AND (
token = 'x7XedcFEcJ77QniaETxXHmW1SEeKBLqAXYfLjzlYBc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)