UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lc50vH7w2IefCt5gufT32DFj/LBQc4GqzZ/WCSxJim4=' 
WHERE 
  key_id = '8c80fe9005e0bd835f88df781c95d6625cc54a4f0b674f55b4752e9373676272' 
  AND (
    token = 'lc50vH7w2IefCt5gufT32DFj/LBQc4GqzZ/WCSxJim4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027