UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8eRbZKtP7ZjuTto1rbGkr5NLCzKluxZvuTvX9xfedg='
WHERE
key_id = '7ae9eed0977b3e1a33b3ff62c0a94c9d42049c247cc02d930b42d9c66935a7d6'
AND (
token = 'i8eRbZKtP7ZjuTto1rbGkr5NLCzKluxZvuTvX9xfedg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)