UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EaZH8gUS5+90a1QhNC1WiWyB7a6HXcj4DkgrAMnEjOI=' 
WHERE 
  key_id = '2f347a63a17cf23154d13fb01c5bc32d003c198c0f16d791f22a724038fa732b' 
  AND (
    token = 'EaZH8gUS5+90a1QhNC1WiWyB7a6HXcj4DkgrAMnEjOI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025