UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'onNza0Z+8L4yXOdOR+sgmN1d/xxTKWmt//Sy2m4+fXM=' 
WHERE 
  key_id = '1250bcbfe29b6da1fb490a7a79f54dcc1e7af7075b0be3bf76860df4e1f5ae78' 
  AND (
    token = 'onNza0Z+8L4yXOdOR+sgmN1d/xxTKWmt//Sy2m4+fXM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021