UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Wxqa+Nyhf0Jd5lVI7YDxCmYqB7omTki2v+bXiSNvaFY=' 
WHERE 
  key_id = '909b239a8419f3d1d9093b8321dfc3aadd6d1a6ac9ee2e6f1d67bb5e24dbc4f6' 
  AND (
    token = 'Wxqa+Nyhf0Jd5lVI7YDxCmYqB7omTki2v+bXiSNvaFY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044