UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NbJc7VKhYn/FO4zBKN9sD7LVYbCR4AeNouJkSjdOuPg='
WHERE
key_id = '7503d03fdaf7d19d148246b429eb1240b5d73edb2e3a6ba44373ab11a1a89cf3'
AND (
token = 'NbJc7VKhYn/FO4zBKN9sD7LVYbCR4AeNouJkSjdOuPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)