UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zuQVABbjQ0qzRfow3knvOvZJVhC2phF+ANIIJFYIlfY=' 
WHERE 
  key_id = '61734df7ea6bc3d906923de81d91b254cab361c4816fc388de1cf65705f16e1e' 
  AND (
    token = 'zuQVABbjQ0qzRfow3knvOvZJVhC2phF+ANIIJFYIlfY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029