UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5XLWy4/emQF1D4NbvPgbgDrI58+0JHCxlYVXUmyJkNE=' 
WHERE 
  key_id = 'ae2573c98a40dd267d92cf172fa31f300ff880fcfd1fde328f21156a0f0b5a4f' 
  AND (
    token = '5XLWy4/emQF1D4NbvPgbgDrI58+0JHCxlYVXUmyJkNE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034