UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'O1q3WwX2VPNxe0SI5Ar6r9cFMo/gac+CuqnX77O1FeY=' 
WHERE 
  key_id = '9c66ba1bfc64288cf7a76f295e27b6a570f555c12cbca9cedd59f41fb7b14be7' 
  AND (
    token = 'O1q3WwX2VPNxe0SI5Ar6r9cFMo/gac+CuqnX77O1FeY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021