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

Query time 0.00027