UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VTCY2bCPeQ4oURj8jEheRKAYR+3EX3sunSvqbw9kmEE=' 
WHERE 
  key_id = 'a52442c2f495091a278e3f24359d1f504aa76a4a549f16af1c5f921d9eee3308' 
  AND (
    token = 'VTCY2bCPeQ4oURj8jEheRKAYR+3EX3sunSvqbw9kmEE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023