UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9z9CFs0OQ1ydkJ64YhC3Jm3kr1C9OuJfowXQ3lHvKc8='
WHERE
key_id = 'c94e38fe5f10afd0c79d1891c07765aed5efcd97796343abd8223040eb70b2fc'
AND (
token = '9z9CFs0OQ1ydkJ64YhC3Jm3kr1C9OuJfowXQ3lHvKc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)