UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '48b0rAyjni6kE1DDPEJM20oelRJ+XTEg8bmZdFdeLE8=' 
WHERE 
  key_id = '3ec465bb2ccf711193737f11ac58e93e0c98f3f091a2ba7139f796f59cd63a62' 
  AND (
    token = '48b0rAyjni6kE1DDPEJM20oelRJ+XTEg8bmZdFdeLE8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026