UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e8qtq57OdbA6oMx2aFJwKv3ESjNqx4fizWjPA0nrcHM='
WHERE
key_id = '8350de2431856fae16e66be61be76dbe06b941161f9a6a415c48fea345c68e5c'
AND (
token = 'e8qtq57OdbA6oMx2aFJwKv3ESjNqx4fizWjPA0nrcHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)