UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NauWR/ENVGtQAqL8eGewzuBYOk62TH4eca3hlmDhY9A=' 
WHERE 
  key_id = '31fb0f99cdb295bb604c0c1ee8c36d2258c31f3379082f5ae408c9333a4b5961' 
  AND (
    token = 'NauWR/ENVGtQAqL8eGewzuBYOk62TH4eca3hlmDhY9A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023