UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnrC3s5PSDHZYKh9J5T6gUPVeUzZNwhIuo7PzVkA1PE='
WHERE
key_id = '818d8e33b6fe88a905e1f65309437f601aaad6bc689ab315cd9a219e8b82ade8'
AND (
token = 'KnrC3s5PSDHZYKh9J5T6gUPVeUzZNwhIuo7PzVkA1PE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)