UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'cR76K8xs2pYI38XVRUHOkw4eqlXmoKMmfi+TT9QBbhk=' 
WHERE 
  key_id = '6608f6209b82f458fd7b37eb0e8fcda17e09929efa44dccbf9f646dd9eb713d7' 
  AND (
    token = 'cR76K8xs2pYI38XVRUHOkw4eqlXmoKMmfi+TT9QBbhk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030