UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O384dw6oKMF9hHAn4bThI+pX6PjB0lZGtFVL0GksP4s='
WHERE
key_id = 'd4167a2dba54c578979981e249cc0aaddf7d03806b98ae6ea5c546bf87225871'
AND (
token = 'O384dw6oKMF9hHAn4bThI+pX6PjB0lZGtFVL0GksP4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)