UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjC+JK91l6pZCVQWyiVNxqrF7y+AcukuOiRZ+N2mx18='
WHERE
key_id = 'f7079a4510dc29226881c9aadf368b6f92c5cd67f706bc875c5adf8631ed8ff0'
AND (
token = 'hjC+JK91l6pZCVQWyiVNxqrF7y+AcukuOiRZ+N2mx18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)