UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YSR+9roAmXRQvCsWkTrVhIS1YObB7wNSFhS42HjPX7Q='
WHERE
key_id = 'a27481254804dbec362e3893effa2174c2aad2a1c6bbf2382a6036704f97447f'
AND (
token = 'YSR+9roAmXRQvCsWkTrVhIS1YObB7wNSFhS42HjPX7Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)